10. Appending Data (cont.)

Appending Data (cont.)

Below is the same notebook you worked on in the previous "Appending Data" section. Add a new cell below the first code cell (where you imported packages and loaded data) to fix the problematic column label in the red dataframe.

Use pandas' rename function to change the total_sulfur-dioxide column label to total_sulfur_dioxide . You can check out this Stack Overflow page to help you.

Then, rerun all the cells below that to append the dataframes and save your successfully combined dataset!

Workspace

This section contains either a workspace (it can be a Jupyter Notebook workspace or an online code editor work space, etc.) and it cannot be automatically downloaded to be generated here. Please access the classroom with your account and manually download the workspace to your local machine. Note that for some courses, Udacity upload the workspace files onto https://github.com/udacity , so you may be able to download them there.

Workspace Information:

  • Default file path:
  • Workspace type: jupyter
  • Opened files (when workspace is loaded): n/a

Add a line at the end of the notebook above to get the dimensions of your newly combined dataset. Use this to answer the following questions.

QUESTION:

How many rows are in the combined dataframe?

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

QUESTION:

How many columns are in the combined dataframe?

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

Next Concept